/*
 Navicat MySQL Data Transfer

 Source Server         : data
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : gt_flutter_boot

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 17/01/2023 23:44:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_data_permission_test
-- ----------------------------
DROP TABLE IF EXISTS `t_data_permission_test`;
CREATE TABLE `t_data_permission_test` (
  `field1` varchar(20) NOT NULL,
  `field2` varchar(20) NOT NULL,
  `field3` varchar(20) NOT NULL,
  `field4` varchar(20) NOT NULL,
  `dept_id` int NOT NULL,
  `create_time` datetime NOT NULL,
  `id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户权限测试';

-- ----------------------------
-- Records of t_data_permission_test
-- ----------------------------
BEGIN;
INSERT INTO `t_data_permission_test` VALUES ('小米', '小米10Pro', '4999', '珍珠白', 1, '2020-04-14 15:00:38', 1);
INSERT INTO `t_data_permission_test` VALUES ('腾讯', '黑鲨游戏手机3', '3799', '铠甲灰', 2, '2020-04-14 15:01:36', 2);
INSERT INTO `t_data_permission_test` VALUES ('华为', '华为P30', '3299', '天空之境', 1, '2020-04-14 15:03:11', 3);
INSERT INTO `t_data_permission_test` VALUES ('华为', '华为P40Pro', '6488', '亮黑色', 3, '2020-04-14 15:04:31', 4);
INSERT INTO `t_data_permission_test` VALUES ('vivo', 'Vivo iQOO 3', '3998', '拉力橙', 4, '2020-04-14 15:05:55', 5);
INSERT INTO `t_data_permission_test` VALUES ('一加', '一加7T', '3199', '冰际蓝', 5, '2020-04-14 15:06:53', 6);
INSERT INTO `t_data_permission_test` VALUES ('三星', '三星Galaxy S10', '4098', '浩玉白', 6, '2020-04-14 15:08:25', 7);
INSERT INTO `t_data_permission_test` VALUES ('苹果', 'iPhone 11 pro max', '9198', '暗夜绿', 4, '2020-04-14 15:09:20', 8);
COMMIT;

-- ----------------------------
-- Table structure for t_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `parent_id` bigint NOT NULL COMMENT '上级部门ID',
  `dept_name` varchar(100) NOT NULL COMMENT '部门名称',
  `order_num` int DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_dept_name` (`dept_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='部门';

-- ----------------------------
-- Records of t_dept
-- ----------------------------
BEGIN;
INSERT INTO `t_dept` VALUES (1, 0, '开发部', 1, '2018-01-04 15:42:26', '2019-01-05 21:08:27');
INSERT INTO `t_dept` VALUES (2, 1, '开发一部', 1, '2018-01-04 15:42:34', '2019-01-18 00:59:37');
INSERT INTO `t_dept` VALUES (3, 1, '开发二部', 2, '2018-01-04 15:42:29', '2019-01-05 14:09:39');
INSERT INTO `t_dept` VALUES (4, 0, '市场部', 2, '2018-01-04 15:42:36', '2019-01-23 06:27:56');
INSERT INTO `t_dept` VALUES (5, 0, '人事部', 3, '2018-01-04 15:42:32', '2019-01-23 06:27:59');
INSERT INTO `t_dept` VALUES (6, 0, '测试部', 4, '2018-01-04 15:42:38', '2019-01-17 08:15:47');
INSERT INTO `t_dept` VALUES (24, 6, '测试部3', 1, '2022-03-27 10:17:29', '2022-03-27 10:19:25');
COMMIT;

-- ----------------------------
-- Table structure for t_file
-- ----------------------------
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE `t_file` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '文件ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '访问链接',
  `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名',
  `file_size` bigint NOT NULL COMMENT '文件大小',
  `bucket_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '桶名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of t_file
-- ----------------------------
BEGIN;
INSERT INTO `t_file` VALUES (1, 1, 'http://127.0.0.1:9000/file/1.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T112803Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=6fed6378f33acc918bb176930b93e4382ea58fc0e6edd6c5a9fdc8b0cab2f01e', '1.jpg', 21224, 'file', '2023-01-13 19:28:04', NULL);
INSERT INTO `t_file` VALUES (2, 1, 'http://127.0.0.1:9000/file/1.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T112823Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=36c4b1d7f1e0a57a0f7225615e9cb79673689d44fe964d459003be7a70645eb7', '1.jpg', 21224, 'file', '2023-01-13 19:28:28', NULL);
INSERT INTO `t_file` VALUES (3, 1, 'http://127.0.0.1:9000/file/2.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T112826Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=da16b4fe7343861127dcc7fbab6c2716c59c00359aff7584d4351cabee4f8d5c', '2.jpg', 25645, 'file', '2023-01-13 19:28:28', NULL);
INSERT INTO `t_file` VALUES (4, 1, 'http://127.0.0.1:9000/file/3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T112827Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=7d49973c946b9587fd4e2a94fd06023b1de05742da31aa6e32850d8a241a5526', '3.jpg', 18410, 'file', '2023-01-13 19:28:28', NULL);
INSERT INTO `t_file` VALUES (5, 1, 'http://127.0.0.1:9000/file/1.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113343Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=3d7439ee671f49cfd9b51f282b7da876dc51d4b8239dfe2fda27baa45446a116', '1.jpg', 21224, 'file', '2023-01-13 19:33:43', NULL);
INSERT INTO `t_file` VALUES (6, 1, 'http://127.0.0.1:9000/file/2.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113343Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=52cbd9abdc3304aff9907ed94d5389b0641dce50b2f7a041b44a500415a078a1', '2.jpg', 25645, 'file', '2023-01-13 19:33:43', NULL);
INSERT INTO `t_file` VALUES (7, 1, 'http://127.0.0.1:9000/file/3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113343Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=102ff235bd6a4a390a8d74faf0290f6959285f499af2b44a6b8674e28c049a2f', '3.jpg', 18410, 'file', '2023-01-13 19:33:43', NULL);
INSERT INTO `t_file` VALUES (8, 1, 'http://127.0.0.1:9000/file/1673609955988_1.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113915Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=6414682ff0aa36a158f0d335b383647fada20a745ce2aa975a6d750e2f721bc0', '1673609955988_1.jpg', 21224, 'file', '2023-01-13 19:39:16', NULL);
INSERT INTO `t_file` VALUES (9, 1, 'http://127.0.0.1:9000/file/1673609955990_2.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113915Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=a9c0aeb4e54eeb967140ebb552df6dafaf9ef20d137be35aa695071097b28da5', '1673609955990_2.jpg', 25645, 'file', '2023-01-13 19:39:16', NULL);
INSERT INTO `t_file` VALUES (10, 1, 'http://127.0.0.1:9000/file/1673609955991_3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T113915Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1c358fa7c368f610a30d7d86f3ea1538dcc7fc5a4300932f225643716751eeaa', '1673609955991_3.jpg', 18410, 'file', '2023-01-13 19:39:16', NULL);
INSERT INTO `t_file` VALUES (11, 1, 'http://127.0.0.1:9000/file/1673610239013-1.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114359Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1bafe63e9a335304676e6ec2f804bff92a22bf66797272ac2767783f28f5acb5', '1673610239013-1.jpg', 21224, 'file', '2023-01-13 19:43:59', NULL);
INSERT INTO `t_file` VALUES (12, 1, 'http://127.0.0.1:9000/file/1673610239018-2.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114359Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=a659f8ad825683515dc52301acfd6f83f5daf3eb7c22a63fcd8f510304a65ffb', '1673610239018-2.jpg', 25645, 'file', '2023-01-13 19:43:59', NULL);
INSERT INTO `t_file` VALUES (13, 1, 'http://127.0.0.1:9000/file/1673610239020-3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114359Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=16de12036a35db1bfdfc9f97ed54a7642a41bd53e91f67b99c39673e1289610a', '1673610239020-3.jpg', 18410, 'file', '2023-01-13 19:43:59', NULL);
INSERT INTO `t_file` VALUES (14, 1, 'http://127.0.0.1:9000/file/16736102874961.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114447Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=cdf60fae31d99700f10543912d4af5a3c4582bbd17169a634eea0ea32c62c591', '16736102874961.jpg', 21224, 'file', '2023-01-13 19:44:48', NULL);
INSERT INTO `t_file` VALUES (15, 1, 'http://127.0.0.1:9000/file/16736102875002.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114447Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=a61c4c06e0658054e70f4567ebcd6ac5a80b44116ae33026941ea7d71d275d23', '16736102875002.jpg', 25645, 'file', '2023-01-13 19:44:48', NULL);
INSERT INTO `t_file` VALUES (16, 1, 'http://127.0.0.1:9000/file/16736102875013.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=admin%2F20230113%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230113T114447Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ac942051d639f77d82ee324379123d7a8f07a62ad26c281916b9066d97564e11', '16736102875013.jpg', 18410, 'file', '2023-01-13 19:44:48', NULL);
INSERT INTO `t_file` VALUES (17, 1, 'http://127.0.0.1:9000/file/1.jpg', '1.jpg', 21224, 'file', '2023-01-13 19:50:33', NULL);
INSERT INTO `t_file` VALUES (18, 1, 'http://127.0.0.1:9000/file/1.jpg', '1.jpg', 18410, 'file', '2023-01-13 19:51:11', NULL);
INSERT INTO `t_file` VALUES (19, 1, 'http://127.0.0.1:9000/file/22.jpg', '22.jpg', 18410, 'file', '2023-01-13 19:51:52', NULL);
INSERT INTO `t_file` VALUES (20, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 21224, 'file', '2023-01-13 19:54:44', NULL);
INSERT INTO `t_file` VALUES (21, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 21224, 'file', '2023-01-13 19:55:37', NULL);
INSERT INTO `t_file` VALUES (22, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-13 20:07:05', NULL);
INSERT INTO `t_file` VALUES (23, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-13 20:08:34', NULL);
INSERT INTO `t_file` VALUES (24, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-13 20:16:54', NULL);
INSERT INTO `t_file` VALUES (25, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-14 09:34:22', NULL);
INSERT INTO `t_file` VALUES (26, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-14 09:35:54', NULL);
INSERT INTO `t_file` VALUES (27, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-14 09:38:21', NULL);
INSERT INTO `t_file` VALUES (28, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-14 09:39:34', NULL);
INSERT INTO `t_file` VALUES (29, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-14 09:46:44', NULL);
INSERT INTO `t_file` VALUES (30, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-14 09:51:43', NULL);
INSERT INTO `t_file` VALUES (31, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-14 09:53:30', NULL);
INSERT INTO `t_file` VALUES (32, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-14 09:54:24', NULL);
INSERT INTO `t_file` VALUES (33, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-14 09:55:45', NULL);
INSERT INTO `t_file` VALUES (34, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-14 10:13:34', NULL);
INSERT INTO `t_file` VALUES (35, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-15 18:42:42', NULL);
INSERT INTO `t_file` VALUES (36, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-15 18:43:45', NULL);
INSERT INTO `t_file` VALUES (37, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-15 18:50:48', NULL);
INSERT INTO `t_file` VALUES (38, 1, 'http://127.0.0.1:9000/file/ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 'ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 1277007, 'file', '2023-01-16 22:11:48', NULL);
INSERT INTO `t_file` VALUES (39, 1, 'http://127.0.0.1:9000/file/ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 'ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 1277007, 'file', '2023-01-16 22:14:04', NULL);
INSERT INTO `t_file` VALUES (40, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-16 22:19:06', NULL);
INSERT INTO `t_file` VALUES (41, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-16 22:38:08', NULL);
INSERT INTO `t_file` VALUES (42, 1, 'http://127.0.0.1:9000/file/eb0ea90bfc8e378002064537f2c890d2_exif.jpg', 'eb0ea90bfc8e378002064537f2c890d2_exif.jpg', 1416789, 'file', '2023-01-16 23:45:09', NULL);
INSERT INTO `t_file` VALUES (43, 1, 'http://127.0.0.1:9000/file/53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', '53b97cdaca226e2c5b7a6df8e9f7476f_exif.jpg', 4766019, 'file', '2023-01-16 23:55:15', NULL);
INSERT INTO `t_file` VALUES (44, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-17 12:54:23', NULL);
INSERT INTO `t_file` VALUES (45, 1, 'http://127.0.0.1:9000/file/eb0ea90bfc8e378002064537f2c890d2_exif.jpg', 'eb0ea90bfc8e378002064537f2c890d2_exif.jpg', 1416789, 'file', '2023-01-17 12:56:01', NULL);
INSERT INTO `t_file` VALUES (46, 1, 'http://127.0.0.1:9000/file/ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 'ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', 1277007, 'file', '2023-01-17 12:57:23', NULL);
INSERT INTO `t_file` VALUES (47, 1, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 'd9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', 13727225, 'file', '2023-01-17 13:14:25', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `username` varchar(50) DEFAULT NULL COMMENT '操作用户',
  `operation` text COMMENT '操作内容',
  `time` decimal(11,0) DEFAULT NULL COMMENT '耗时',
  `method` text COMMENT '操作方法',
  `params` text COMMENT '方法参数',
  `ip` varchar(64) DEFAULT NULL COMMENT '操作者IP',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `location` varchar(50) DEFAULT NULL COMMENT '操作地点',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `t_log_create_time` (`create_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户操作日志';

-- ----------------------------
-- Table structure for t_login_log
-- ----------------------------
DROP TABLE IF EXISTS `t_login_log`;
CREATE TABLE `t_login_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `login_time` datetime NOT NULL COMMENT '登录时间',
  `login_location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '登录地点',
  `ip` varchar(50) DEFAULT NULL COMMENT 'IP地址',
  `login_system` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作系统',
  `login_browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '浏览器',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `t_login_log_login_time` (`login_time`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='登录日志';

-- ----------------------------
-- Records of t_login_log
-- ----------------------------
BEGIN;
INSERT INTO `t_login_log` VALUES (93, 'gt', '2021-10-22 17:32:27', '127.0.0.1', '127.0.0.1', 'Mac OS X 10.15; ', 'Firefox 92');
INSERT INTO `t_login_log` VALUES (94, 'gt', '2022-03-26 13:51:33', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 15.3 Sa');
INSERT INTO `t_login_log` VALUES (95, 'gt', '2022-03-27 13:12:56', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 15.3 Sa');
INSERT INTO `t_login_log` VALUES (96, 'gt1', '2022-03-27 13:16:10', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 15.3 Sa');
INSERT INTO `t_login_log` VALUES (97, 'gt', '2022-03-27 15:43:25', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 15.3 Sa');
INSERT INTO `t_login_log` VALUES (98, 'gt', '2023-01-02 20:13:38', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 16.1 Sa');
INSERT INTO `t_login_log` VALUES (99, 'gt', '2023-01-05 15:55:57', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (100, 'gt', '2023-01-05 16:05:36', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (101, 'gt', '2023-01-05 16:06:14', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (102, 'gt', '2023-01-05 16:37:45', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (103, 'gt', '2023-01-05 19:39:15', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (104, 'gt', '2023-01-06 15:52:11', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 16.1 Sa');
INSERT INTO `t_login_log` VALUES (105, 'gt', '2023-01-06 17:43:06', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (106, 'gt', '2023-01-06 17:58:47', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (107, 'gt', '2023-01-06 18:41:46', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (108, 'gt', '2023-01-07 23:24:08', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Chrome 10');
INSERT INTO `t_login_log` VALUES (109, 'gt', '2023-01-07 23:41:17', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (110, 'gt', '2023-01-12 21:21:24', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (111, 'gt', '2023-01-12 21:22:27', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (112, 'gt', '2023-01-12 21:30:11', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (113, 'gt', '2023-01-12 21:36:49', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (114, 'gt', '2023-01-12 21:51:23', '127.0.0.1', '127.0.0.1', '', '');
INSERT INTO `t_login_log` VALUES (115, 'gt', '2023-01-13 19:19:41', '127.0.0.1', '127.0.0.1', 'Mac OS X 10_15_7', 'Safari Version 16.1 Sa');
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单/按钮ID',
  `parent_id` bigint DEFAULT NULL COMMENT '上级菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单/按钮名称',
  `path` varchar(255) DEFAULT NULL COMMENT '对应路由path',
  `perms` varchar(50) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `type` char(2) NOT NULL COMMENT '类型 0菜单 1按钮',
  `order_num` int DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='菜单';

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES (2, 0, '系统管理', NULL, NULL, '0xe57f', '0', 2, '2021-10-20 15:10:00', '2021-10-21 12:31:16');
INSERT INTO `t_menu` VALUES (3, 2, '用户管理', '/user', 'user:list', '0xe491', '0', 1, '2021-10-20 15:10:42', NULL);
INSERT INTO `t_menu` VALUES (4, 2, '菜单管理', '/menu', 'menu:list', '0xe3dc', '0', 2, '2021-10-20 15:10:42', NULL);
INSERT INTO `t_menu` VALUES (5, 2, '角色管理', '/role', 'role:list', '0xe2eb', '0', 3, '2021-10-20 15:10:42', NULL);
INSERT INTO `t_menu` VALUES (6, 2, '部门管理', '/dept', 'dept:list', '0xe044', '0', 4, '2021-10-20 15:10:42', NULL);
INSERT INTO `t_menu` VALUES (8, 3, '新增用户', NULL, 'user:add', NULL, '1', NULL, '2021-10-20 15:16:01', '2021-10-21 12:27:00');
INSERT INTO `t_menu` VALUES (9, 3, '修改用户', NULL, 'user:update', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (10, 3, '删除用户', NULL, 'user:delete', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (11, 5, '新增角色', NULL, 'role:add', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (12, 5, '修改角色', NULL, 'role:update', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (13, 5, '删除角色', NULL, 'role:delete', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (14, 4, '新增菜单', NULL, 'menu:add', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (15, 4, '修改菜单', NULL, 'menu:update', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (16, 4, '删除菜单', NULL, 'menu:delete', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (17, 6, '新增部门', NULL, 'dept:add', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (18, 6, '修改部门', NULL, 'dept:update', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (19, 6, '删除部门', NULL, 'dept:delete', NULL, '1', NULL, '2021-10-20 15:16:01', NULL);
INSERT INTO `t_menu` VALUES (20, 3, '密码重置', NULL, 'user:reset', NULL, '1', NULL, '2021-10-20 15:16:01', '2021-10-21 12:25:04');
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(10) NOT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '角色描述',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_role_name` (`role_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='角色';

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES (1, '管理员', '管理员', '2017-12-27 16:23:11', '2020-04-15 14:02:27');
INSERT INTO `t_role` VALUES (2, '普通用户', '可查看，新增，导出', '2019-01-04 14:11:28', '2021-10-21 17:44:19');
COMMIT;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `role_id` bigint NOT NULL,
  `menu_id` bigint NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='角色菜单关联';

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_role_menu` VALUES (1, 2);
INSERT INTO `t_role_menu` VALUES (1, 3);
INSERT INTO `t_role_menu` VALUES (1, 4);
INSERT INTO `t_role_menu` VALUES (1, 5);
INSERT INTO `t_role_menu` VALUES (1, 6);
INSERT INTO `t_role_menu` VALUES (1, 7);
INSERT INTO `t_role_menu` VALUES (1, 8);
INSERT INTO `t_role_menu` VALUES (1, 9);
INSERT INTO `t_role_menu` VALUES (1, 10);
INSERT INTO `t_role_menu` VALUES (1, 11);
INSERT INTO `t_role_menu` VALUES (1, 12);
INSERT INTO `t_role_menu` VALUES (1, 13);
INSERT INTO `t_role_menu` VALUES (1, 14);
INSERT INTO `t_role_menu` VALUES (1, 15);
INSERT INTO `t_role_menu` VALUES (1, 16);
INSERT INTO `t_role_menu` VALUES (1, 17);
INSERT INTO `t_role_menu` VALUES (1, 18);
INSERT INTO `t_role_menu` VALUES (1, 19);
INSERT INTO `t_role_menu` VALUES (1, 20);
INSERT INTO `t_role_menu` VALUES (1, 21);
INSERT INTO `t_role_menu` VALUES (1, 22);
INSERT INTO `t_role_menu` VALUES (1, 23);
INSERT INTO `t_role_menu` VALUES (1, 24);
INSERT INTO `t_role_menu` VALUES (1, 25);
INSERT INTO `t_role_menu` VALUES (1, 26);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(128) NOT NULL COMMENT '密码',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `status` char(1) NOT NULL COMMENT '状态 0锁定 1有效',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最近访问时间',
  `sex` char(1) DEFAULT NULL COMMENT '性别 0男 1女 2保密',
  `is_tab` char(1) DEFAULT NULL COMMENT '是否开启tab，0关闭 1开启',
  `theme` varchar(10) DEFAULT NULL COMMENT '主题',
  `avatar` varchar(100) DEFAULT NULL COMMENT '头像',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_user_mobile` (`mobile`) USING BTREE,
  KEY `idx_user_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户';

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (1, 'gt', '$2a$10$fJlitylw6VbicJg1JwL1ceAIX0STqEIcAd6zeaOe9IG0Dc9AcNFLC', 2, '714141681@qq.com', '15159398913', '1', '2019-06-14 20:39:22', '2022-03-27 16:05:00', '2023-01-13 19:19:41', '0', '1', 'white', 'https://img1.baidu.com/it/u=1897719880,2867606276&fm=26&fmt=auto', 'hh');
INSERT INTO `t_user` VALUES (15, 'gt1', '$2a$10$fJlitylw6VbicJg1JwL1ceAIX0STqEIcAd6zeaOe9IG0Dc9AcNFLC', 2, '714141681@qq.com', '15159398912', '1', '2019-06-11 20:39:22', '2021-10-17 21:05:58', '2022-03-27 13:16:10', '0', '1', 'white', 'https://img1.baidu.com/it/u=1897719880,2867606276&fm=26&fmt=auto', 'hh');
INSERT INTO `t_user` VALUES (32, 'aasd', '$2a$10$KlCR1DzXWZzA.MI6OWB3Des.dThNIzSScEi3Mcd09NDpJyXiHnJ8a', 24, 'sdfas@qq.com', '13189098232', '1', '2023-01-17 12:54:27', NULL, NULL, '1', NULL, NULL, 'http://127.0.0.1:9000/file/d9ddb2824e1053b4ed1c8a3633477a07_exif.jpg', '1231');
INSERT INTO `t_user` VALUES (33, 'aa', '$2a$10$D.PuGMwQDtAUfgDJPc/dWOaY2d1J25dWADgctMIQrANv1ZEMTA13u', 24, 'asd@qq.com', '13123239090', '1', '2023-01-17 12:56:08', NULL, NULL, '1', NULL, NULL, 'http://127.0.0.1:9000/file/eb0ea90bfc8e378002064537f2c890d2_exif.jpg', '12312');
INSERT INTO `t_user` VALUES (34, 'bb', '$2a$10$c8F.w7jjy1y54KyFeosORe/9eL2hPUe2sL6LTp2ZIFQ6aQYEVkf.m', 24, '123@qq.com', '13189892323', '1', '2023-01-17 12:57:30', NULL, NULL, '1', NULL, NULL, 'http://127.0.0.1:9000/file/ff30a02d4afc1e01dfd8af09205f3f7b_exif.jpg', '12312');
COMMIT;

-- ----------------------------
-- Table structure for t_user_connection
-- ----------------------------
DROP TABLE IF EXISTS `t_user_connection`;
CREATE TABLE `t_user_connection` (
  `user_name` varchar(50) NOT NULL COMMENT 'GT系统用户名',
  `provider_name` varchar(20) NOT NULL COMMENT '第三方平台名称',
  `provider_user_id` varchar(50) NOT NULL COMMENT '第三方平台账户ID',
  `provider_user_name` varchar(50) DEFAULT NULL COMMENT '第三方平台用户名',
  `nick_name` varchar(50) DEFAULT NULL COMMENT '第三方平台昵称',
  `image_url` varchar(512) DEFAULT NULL COMMENT '第三方平台头像',
  `location` varchar(255) DEFAULT NULL COMMENT '地址',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_name`,`provider_name`,`provider_user_id`) USING BTREE,
  UNIQUE KEY `uk_user_name_provider_name_provider_user_id` (`user_name`,`provider_name`,`provider_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统用户社交账户关联';

-- ----------------------------
-- Table structure for t_user_data_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_user_data_permission`;
CREATE TABLE `t_user_data_permission` (
  `user_id` bigint NOT NULL,
  `dept_id` bigint NOT NULL,
  PRIMARY KEY (`user_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户数据权限关联';

-- ----------------------------
-- Records of t_user_data_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_user_data_permission` VALUES (1, 1);
INSERT INTO `t_user_data_permission` VALUES (1, 2);
INSERT INTO `t_user_data_permission` VALUES (1, 3);
INSERT INTO `t_user_data_permission` VALUES (1, 4);
INSERT INTO `t_user_data_permission` VALUES (1, 5);
INSERT INTO `t_user_data_permission` VALUES (1, 6);
INSERT INTO `t_user_data_permission` VALUES (15, 1);
INSERT INTO `t_user_data_permission` VALUES (15, 2);
INSERT INTO `t_user_data_permission` VALUES (32, 4);
INSERT INTO `t_user_data_permission` VALUES (33, 4);
INSERT INTO `t_user_data_permission` VALUES (34, 24);
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户角色关联';

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES (1, 1);
INSERT INTO `t_user_role` VALUES (15, 2);
INSERT INTO `t_user_role` VALUES (32, 2);
INSERT INTO `t_user_role` VALUES (33, 2);
INSERT INTO `t_user_role` VALUES (34, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
